Dataset statistics
| Number of variables | 50 |
|---|---|
| Number of observations | 48982 |
| Missing cells | 388519 |
| Missing cells (%) | 15.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 18.7 MiB |
| Average record size in memory | 400.0 B |
Variable types
| CAT | 32 |
|---|---|
| NUM | 18 |
FECHAENTRADA has a high cardinality: 494 distinct values | High cardinality |
FECHASALIDA has a high cardinality: 426 distinct values | High cardinality |
FECHAACTUALIZACION has a high cardinality: 395 distinct values | High cardinality |
FECHAMORADESDE has a high cardinality: 1921 distinct values | High cardinality |
FECHAMOVIMIENTO has a high cardinality: 517 distinct values | High cardinality |
VCTO_CUOTA1 has a high cardinality: 954 distinct values | High cardinality |
FECHA_VCTO has a high cardinality: 2047 distinct values | High cardinality |
FECHAULTPAGO has a high cardinality: 1130 distinct values | High cardinality |
MUNICRESIDENCIA has a high cardinality: 824 distinct values | High cardinality |
IES has a high cardinality: 297 distinct values | High cardinality |
NOMBREPROGRAMA has a high cardinality: 2279 distinct values | High cardinality |
SUBLINEA has a high cardinality: 74 distinct values | High cardinality |
FECHA_ACUERDO has a high cardinality: 1423 distinct values | High cardinality |
fecha Venc Cuota Vigente has a high cardinality: 103 distinct values | High cardinality |
Valor Cuota Vigente has a high cardinality: 6843 distinct values | High cardinality |
RazonSocial has a high cardinality: 19241 distinct values | High cardinality |
UltimoPeriodoCotizado has a high cardinality: 174 distinct values | High cardinality |
Tipificacion has a high cardinality: 92 distinct values | High cardinality |
SALDOCAPITALACIERRE is highly correlated with SALDOTOTAL_ACT and 1 other fields | High correlation |
SALDOTOTAL_ACT is highly correlated with SALDOCAPITALACIERRE and 1 other fields | High correlation |
CAPITALICETEX_ACT is highly correlated with SALDOTOTAL_ACT and 1 other fields | High correlation |
SUBLINEA is highly correlated with LINEA | High correlation |
LINEA is highly correlated with SUBLINEA | High correlation |
FECHASALIDA has 37376 (76.3%) missing values | Missing |
FECHAMORADESDE has 6955 (14.2%) missing values | Missing |
NROCUOTASMORA has 651 (1.3%) missing values | Missing |
CALIFICACIONACTUAL has 2592 (5.3%) missing values | Missing |
VCTO_CUOTA1 has 1034 (2.1%) missing values | Missing |
FECHA_VCTO has 990 (2.0%) missing values | Missing |
FECHAULTPAGO has 28842 (58.9%) missing values | Missing |
IES has 1136 (2.3%) missing values | Missing |
NOMBREPROGRAMA has 1148 (2.3%) missing values | Missing |
ESTADOACTUAL has 2909 (5.9%) missing values | Missing |
ESTRATO has 3002 (6.1%) missing values | Missing |
SEXO has 3123 (6.4%) missing values | Missing |
ESTADOCIVIL has 2964 (6.1%) missing values | Missing |
Rangodiasmora has 12305 (25.1%) missing values | Missing |
CONCEPTO has 14625 (29.9%) missing values | Missing |
FECHA_ACUERDO has 15306 (31.2%) missing values | Missing |
ESTADO_ACUERDO has 15306 (31.2%) missing values | Missing |
TIPO_ACUERDO has 15306 (31.2%) missing values | Missing |
CUOTAS_PAGADAS_ACUERDO has 23473 (47.9%) missing values | Missing |
CUOTAS_MORA_ACUERDO has 23473 (47.9%) missing values | Missing |
CUOTAS_FUTURAS_ACUERDO has 23473 (47.9%) missing values | Missing |
fecha Venc Cuota Vigente has 33410 (68.2%) missing values | Missing |
Valor Cuota Vigente has 15306 (31.2%) missing values | Missing |
No. ACUERDOS DE PAGO has 15306 (31.2%) missing values | Missing |
RazonSocial has 17908 (36.6%) missing values | Missing |
UltimoPeriodoCotizado has 14172 (28.9%) missing values | Missing |
FechaFosyga has 14172 (28.9%) missing values | Missing |
Hora_ContactoEfectivo has 20802 (42.5%) missing values | Missing |
Llamadas_recibidas has 11236 (22.9%) missing values | Missing |
Llamadas_realizadas has 3240 (6.6%) missing values | Missing |
Tipificacion has 2524 (5.2%) missing values | Missing |
VALORCUOTA is highly skewed (γ1 = 33.51314313) | Skewed |
CUOTAS_FUTURAS_ACUERDO is highly skewed (γ1 = 21.17064286) | Skewed |
IDSOLICITUD has unique values | Unique |
NROCUOTASMORA has 5602 (11.4%) zeros | Zeros |
NUMDIASMORA_ACT has 8733 (17.8%) zeros | Zeros |
VALORCUOTA has 786 (1.6%) zeros | Zeros |
SALDOTOTALMORA1_ACT has 8418 (17.2%) zeros | Zeros |
SALDOTOTAL_ACT has 2105 (4.3%) zeros | Zeros |
CODSNIES_INST has 828 (1.7%) zeros | Zeros |
CAPITALICETEX_ACT has 3863 (7.9%) zeros | Zeros |
CUOTAS_PAGADAS_ACUERDO has 14348 (29.3%) zeros | Zeros |
CUOTAS_MORA_ACUERDO has 12558 (25.6%) zeros | Zeros |
CUOTAS_FUTURAS_ACUERDO has 25087 (51.2%) zeros | Zeros |
Reproduction
| Analysis started | 2020-12-01 20:03:18.791605 |
|---|---|
| Analysis finished | 2020-12-01 20:04:47.377204 |
| Duration | 1 minute and 28.59 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 48982 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1511724.602 |
|---|---|
| Minimum | 23 |
| Maximum | 3934204 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 382.7 KiB |
Quantile statistics
| Minimum | 23 |
|---|---|
| 5-th percentile | 79240.8 |
| Q1 | 432336 |
| median | 1609889 |
| Q3 | 2309858.25 |
| 95-th percentile | 3091331.55 |
| Maximum | 3934204 |
| Range | 3934181 |
| Interquartile range (IQR) | 1877522.25 |
Descriptive statistics
| Standard deviation | 987382.5691 |
|---|---|
| Coefficient of variation (CV) | 0.6531497655 |
| Kurtosis | -1.103970038 |
| Mean | 1511724.602 |
| Median Absolute Deviation (MAD) | 914245.5 |
| Skewness | 0.04443426226 |
| Sum | 7.404729444e+10 |
| Variance | 9.749243378e+11 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 3475455 | 1 | < 0.1% | |
| 2977159 | 1 | < 0.1% | |
| 1701268 | 1 | < 0.1% | |
| 3067283 | 1 | < 0.1% | |
| 1546447 | 1 | < 0.1% | |
| 412413 | 1 | < 0.1% | |
| 273807 | 1 | < 0.1% | |
| 1785229 | 1 | < 0.1% | |
| 69003 | 1 | < 0.1% | |
| 2629001 | 1 | < 0.1% | |
| Other values (48972) | 48972 | > 99.9% |
| Value | Count | Frequency (%) | |
| 23 | 1 | < 0.1% | |
| 39 | 1 | < 0.1% | |
| 47 | 1 | < 0.1% | |
| 60 | 1 | < 0.1% | |
| 68 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 3934204 | 1 | < 0.1% | |
| 3897316 | 1 | < 0.1% | |
| 3863349 | 1 | < 0.1% | |
| 3828530 | 1 | < 0.1% | |
| 3828315 | 1 | < 0.1% |
| Distinct | 494 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 382.7 KiB |
| 2019-11-13 | |
|---|---|
| 2020-07-07 | |
| 2020-09-08 | |
| 2020-09-22 | 1534 |
| 2020-06-24 | 1508 |
| Other values (489) |
| Value | Count | Frequency (%) | |
| 2019-11-13 | 16752 | 34.2% | |
| 2020-07-07 | 10140 | 20.7% | |
| 2020-09-08 | 1873 | 3.8% | |
| 2020-09-22 | 1534 | 3.1% | |
| 2020-06-24 | 1508 | 3.1% | |
| 2018-11-01 | 1213 | 2.5% | |
| 2020-08-18 | 1115 | 2.3% | |
| 2020-02-26 | 1093 | 2.2% | |
| 2020-11-10 | 786 | 1.6% | |
| 2020-11-01 | 718 | 1.5% | |
| Other values (484) | 12250 | 25.0% |
Unique
| Unique | 133 ? |
|---|---|
| Unique (%) | 0.3% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
| Distinct | 426 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 37376 |
| Missing (%) | 76.3% |
| Memory size | 382.7 KiB |
| 2020-08-19 | |
|---|---|
| 2019-04-04 | 300 |
| 2020-11-10 | 228 |
| 2020-10-16 | 214 |
| 2019-11-12 | 160 |
| Other values (421) |
| Value | Count | Frequency (%) | |
| 2020-08-19 | 1035 | 2.1% | |
| 2019-04-04 | 300 | 0.6% | |
| 2020-11-10 | 228 | 0.5% | |
| 2020-10-16 | 214 | 0.4% | |
| 2019-11-12 | 160 | 0.3% | |
| 2020-09-23 | 139 | 0.3% | |
| 2019-01-15 | 131 | 0.3% | |
| 2020-10-08 | 129 | 0.3% | |
| 2019-05-07 | 117 | 0.2% | |
| 2020-11-11 | 117 | 0.2% | |
| Other values (416) | 9036 | 18.4% | |
| (Missing) | 37376 | 76.3% |
Unique
| Unique | 33 ? |
|---|---|
| Unique (%) | 0.3% |
Length
| Max length | 10 |
|---|---|
| Median length | 3 |
| Mean length | 4.658609285 |
| Min length | 3 |
| Distinct | 395 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 382.7 KiB |
| 2019-11-13 | |
|---|---|
| 2020-07-07 | |
| 2020-09-08 | 1863 |
| 2020-09-22 | 1538 |
| 2020-06-24 | 1460 |
| Other values (390) |
| Value | Count | Frequency (%) | |
| 2019-11-13 | 14471 | 29.5% | |
| 2020-07-07 | 9633 | 19.7% | |
| 2020-09-08 | 1863 | 3.8% | |
| 2020-09-22 | 1538 | 3.1% | |
| 2020-06-24 | 1460 | 3.0% | |
| 2020-02-26 | 1111 | 2.3% | |
| 2020-08-19 | 1047 | 2.1% | |
| 2020-11-10 | 894 | 1.8% | |
| 2020-07-03 | 659 | 1.3% | |
| 2019-04-04 | 311 | 0.6% | |
| Other values (385) | 15995 | 32.7% |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
| Distinct | 1921 |
|---|---|
| Distinct (%) | 4.6% |
| Missing | 6955 |
| Missing (%) | 14.2% |
| Memory size | 382.7 KiB |
| 2019-01-05 | 2595 |
|---|---|
| 2017-07-05 | 1111 |
| 2019-05-05 | 953 |
| 2018-11-05 | 876 |
| 2019-02-05 | 870 |
| Other values (1916) |
| Value | Count | Frequency (%) | |
| 2019-01-05 | 2595 | 5.3% | |
| 2017-07-05 | 1111 | 2.3% | |
| 2019-05-05 | 953 | 1.9% | |
| 2018-11-05 | 876 | 1.8% | |
| 2019-02-05 | 870 | 1.8% | |
| 2018-02-05 | 813 | 1.7% | |
| 2017-01-20 | 744 | 1.5% | |
| 2019-04-05 | 658 | 1.3% | |
| 2019-03-20 | 547 | 1.1% | |
| 2018-08-05 | 534 | 1.1% | |
| Other values (1911) | 32326 | 66.0% | |
| (Missing) | 6955 | 14.2% |
Unique
| Unique | 752 ? |
|---|---|
| Unique (%) | 1.8% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.006063452 |
| Min length | 3 |
| Distinct | 91 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 651 |
| Missing (%) | 1.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.73381474 |
|---|---|
| Minimum | 0 |
| Maximum | 124 |
| Zeros | 5602 |
| Zeros (%) | 11.4% |
| Memory size | 382.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 13 |
| Q3 | 21 |
| 95-th percentile | 47 |
| Maximum | 124 |
| Range | 124 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 14.54075128 |
|---|---|
| Coefficient of variation (CV) | 0.9868965734 |
| Kurtosis | 1.085486307 |
| Mean | 14.73381474 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 1.139595524 |
| Sum | 712100 |
| Variance | 211.4334477 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 8789 | 17.9% | |
| 0 | 5602 | 11.4% | |
| 17 | 3001 | 6.1% | |
| 12 | 2424 | 4.9% | |
| 55 | 1603 | 3.3% | |
| 24 | 1540 | 3.1% | |
| 14 | 1442 | 2.9% | |
| 20 | 1404 | 2.9% | |
| 16 | 1393 | 2.8% | |
| 18 | 1361 | 2.8% | |
| Other values (81) | 19772 | 40.4% |
| Value | Count | Frequency (%) | |
| 0 | 5602 | 11.4% | |
| 1 | 8789 | 17.9% | |
| 2 | 1087 | 2.2% | |
| 3 | 825 | 1.7% | |
| 4 | 799 | 1.6% |
| Value | Count | Frequency (%) | |
| 124 | 1 | < 0.1% | |
| 118 | 1 | < 0.1% | |
| 110 | 1 | < 0.1% | |
| 108 | 1 | < 0.1% | |
| 107 | 1 | < 0.1% |
| Distinct | 2791 |
|---|---|
| Distinct (%) | 5.7% |
| Missing | 74 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 699.8280445 |
|---|---|
| Minimum | 0 |
| Maximum | 7105 |
| Zeros | 8733 |
| Zeros (%) | 17.8% |
| Memory size | 382.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 5 |
| median | 548 |
| Q3 | 1003 |
| 95-th percentile | 2428 |
| Maximum | 7105 |
| Range | 7105 |
| Interquartile range (IQR) | 998 |
Descriptive statistics
| Standard deviation | 808.4130065 |
|---|---|
| Coefficient of variation (CV) | 1.155159489 |
| Kurtosis | 4.28414568 |
| Mean | 699.8280445 |
| Median Absolute Deviation (MAD) | 522 |
| Skewness | 1.890921665 |
| Sum | 34227190 |
| Variance | 653531.5891 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 8733 | 17.8% | |
| 4 | 2847 | 5.8% | |
| 548 | 2281 | 4.7% | |
| 428 | 763 | 1.6% | |
| 5 | 714 | 1.5% | |
| 517 | 706 | 1.4% | |
| 6 | 660 | 1.3% | |
| 1027 | 639 | 1.3% | |
| 645 | 631 | 1.3% | |
| 609 | 552 | 1.1% | |
| Other values (2781) | 30382 | 62.0% |
| Value | Count | Frequency (%) | |
| 0 | 8733 | 17.8% | |
| 1 | 45 | 0.1% | |
| 2 | 38 | 0.1% | |
| 3 | 32 | 0.1% | |
| 4 | 2847 | 5.8% |
| Value | Count | Frequency (%) | |
| 7105 | 1 | < 0.1% | |
| 5796 | 2 | < 0.1% | |
| 5765 | 1 | < 0.1% | |
| 5583 | 1 | < 0.1% | |
| 5467 | 1 | < 0.1% |
| Distinct | 46532 |
|---|---|
| Distinct (%) | 95.6% |
| Missing | 319 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 229429.5811 |
|---|---|
| Minimum | -222527.42 |
| Maximum | 38757829 |
| Zeros | 786 |
| Zeros (%) | 1.6% |
| Memory size | 382.7 KiB |
Quantile statistics
| Minimum | -222527.42 |
|---|---|
| 5-th percentile | 23082.654 |
| Q1 | 95207.5 |
| median | 164259.85 |
| Q3 | 268769.5 |
| 95-th percentile | 583414.8 |
| Maximum | 38757829 |
| Range | 38980356.42 |
| Interquartile range (IQR) | 173562 |
Descriptive statistics
| Standard deviation | 456157.3658 |
|---|---|
| Coefficient of variation (CV) | 1.988223853 |
| Kurtosis | 1881.28009 |
| Mean | 229429.5811 |
| Median Absolute Deviation (MAD) | 81033.4 |
| Skewness | 33.51314313 |
| Sum | 1.116473171e+10 |
| Variance | 2.080795424e+11 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 786 | 1.6% | |
| 82543 | 17 | < 0.1% | |
| 880 | 10 | < 0.1% | |
| 87881 | 8 | < 0.1% | |
| 82817 | 8 | < 0.1% | |
| 115037 | 8 | < 0.1% | |
| 54972 | 8 | < 0.1% | |
| 105807 | 8 | < 0.1% | |
| 100895 | 7 | < 0.1% | |
| 113763 | 7 | < 0.1% | |
| Other values (46522) | 47796 | 97.6% | |
| (Missing) | 319 | 0.7% |
| Value | Count | Frequency (%) | |
| -222527.42 | 1 | < 0.1% | |
| -68484.1 | 1 | < 0.1% | |
| -3160.87 | 1 | < 0.1% | |
| 0 | 786 | 1.6% | |
| 0.11 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 38757829 | 1 | < 0.1% | |
| 26795164 | 1 | < 0.1% | |
| 24508615 | 1 | < 0.1% | |
| 22408113.99 | 1 | < 0.1% | |
| 18446118 | 1 | < 0.1% |
| Distinct | 39887 |
|---|---|
| Distinct (%) | 82.0% |
| Missing | 319 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4326886.624 |
|---|---|
| Minimum | 0 |
| Maximum | 95345584.28 |
| Zeros | 8418 |
| Zeros (%) | 17.2% |
| Memory size | 382.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 199752.28 |
| median | 2409915.18 |
| Q3 | 5676536.385 |
| 95-th percentile | 15463038.59 |
| Maximum | 95345584.28 |
| Range | 95345584.28 |
| Interquartile range (IQR) | 5476784.105 |
Descriptive statistics
| Standard deviation | 6327928.17 |
|---|---|
| Coefficient of variation (CV) | 1.462466831 |
| Kurtosis | 20.96088343 |
| Mean | 4326886.624 |
| Median Absolute Deviation (MAD) | 2359520.66 |
| Skewness | 3.605394993 |
| Sum | 2.105592838e+11 |
| Variance | 4.004267493e+13 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 8418 | 17.2% | |
| 1604594.17 | 17 | < 0.1% | |
| 4460496.48 | 7 | < 0.1% | |
| 5385244.59 | 7 | < 0.1% | |
| 1966423.68 | 7 | < 0.1% | |
| 1406082.31 | 6 | < 0.1% | |
| 2073324.43 | 6 | < 0.1% | |
| 1638433.44 | 6 | < 0.1% | |
| 3090958.6 | 5 | < 0.1% | |
| 1338213.81 | 5 | < 0.1% | |
| Other values (39877) | 40179 | 82.0% | |
| (Missing) | 319 | 0.7% |
| Value | Count | Frequency (%) | |
| 0 | 8418 | 17.2% | |
| 1.01 | 1 | < 0.1% | |
| 1.04 | 1 | < 0.1% | |
| 1.1 | 1 | < 0.1% | |
| 1.11 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 95345584.28 | 1 | < 0.1% | |
| 89503374.45 | 1 | < 0.1% | |
| 83325425.36 | 1 | < 0.1% | |
| 79976431.75 | 1 | < 0.1% | |
| 78854847.89 | 1 | < 0.1% |
| Distinct | 46021 |
|---|---|
| Distinct (%) | 94.6% |
| Missing | 319 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8411400.313 |
|---|---|
| Minimum | -19509915.75 |
| Maximum | 113877907.3 |
| Zeros | 2105 |
| Zeros (%) | 4.3% |
| Memory size | 382.7 KiB |
Quantile statistics
| Minimum | -19509915.75 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2169046.955 |
| median | 5613834.84 |
| Q3 | 11188705.32 |
| 95-th percentile | 26796530.29 |
| Maximum | 113877907.3 |
| Range | 133387823 |
| Interquartile range (IQR) | 9019658.365 |
Descriptive statistics
| Standard deviation | 9615150.287 |
|---|---|
| Coefficient of variation (CV) | 1.143109343 |
| Kurtosis | 10.72306396 |
| Mean | 8411400.313 |
| Median Absolute Deviation (MAD) | 4041702.68 |
| Skewness | 2.6270489 |
| Sum | 4.093239734e+11 |
| Variance | 9.245111504e+13 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 2105 | 4.3% | |
| 1 | 22 | < 0.1% | |
| 1604594.17 | 17 | < 0.1% | |
| -34 | 10 | < 0.1% | |
| -15 | 9 | < 0.1% | |
| -7 | 9 | < 0.1% | |
| -31 | 9 | < 0.1% | |
| -43 | 9 | < 0.1% | |
| -5 | 8 | < 0.1% | |
| -18 | 8 | < 0.1% | |
| Other values (46011) | 46457 | 94.8% | |
| (Missing) | 319 | 0.7% |
| Value | Count | Frequency (%) | |
| -19509915.75 | 1 | < 0.1% | |
| -13755959.58 | 1 | < 0.1% | |
| -12416641.13 | 1 | < 0.1% | |
| -10200329.15 | 1 | < 0.1% | |
| -8913752.49 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 113877907.3 | 1 | < 0.1% | |
| 106794779.3 | 1 | < 0.1% | |
| 103620867.8 | 1 | < 0.1% | |
| 102902115.2 | 1 | < 0.1% | |
| 100504771.6 | 1 | < 0.1% |
| Distinct | 517 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 74 |
| Missing (%) | 0.2% |
| Memory size | 382.7 KiB |
| 2019-11-13 | |
|---|---|
| 2020-07-07 | |
| 2020-09-08 | 1863 |
| 2020-09-22 | 1538 |
| 2020-06-24 | 1460 |
| Other values (512) |
| Value | Count | Frequency (%) | |
| 2019-11-13 | 14480 | 29.6% | |
| 2020-07-07 | 9633 | 19.7% | |
| 2020-09-08 | 1863 | 3.8% | |
| 2020-09-22 | 1538 | 3.1% | |
| 2020-06-24 | 1460 | 3.0% | |
| 2020-02-26 | 1111 | 2.3% | |
| 2020-08-19 | 1047 | 2.1% | |
| 2020-11-10 | 894 | 1.8% | |
| 2020-07-03 | 659 | 1.3% | |
| 2019-04-04 | 311 | 0.6% | |
| Other values (507) | 15912 | 32.5% |
Unique
| Unique | 89 ? |
|---|---|
| Unique (%) | 0.2% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.989424687 |
| Min length | 3 |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2592 |
| Missing (%) | 5.3% |
| Memory size | 382.7 KiB |
| K | |
|---|---|
| E | |
| DD | 78 |
| D | 74 |
| K | 41 |
| Other values (2) | 2 |
| Value | Count | Frequency (%) | |
| K | 36696 | 74.9% | |
| E | 9499 | 19.4% | |
| DD | 78 | 0.2% | |
| D | 74 | 0.2% | |
| K | 41 | 0.1% | |
| BB | 1 | < 0.1% | |
| AA | 1 | < 0.1% | |
| (Missing) | 2592 | 5.3% |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 5 |
|---|---|
| Median length | 1 |
| Mean length | 1.110816218 |
| Min length | 1 |
| Distinct | 954 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 1034 |
| Missing (%) | 2.1% |
| Memory size | 382.7 KiB |
| 2019-01-05 | 2680 |
|---|---|
| 2018-12-05 | 2420 |
| 2015-12-17 | 1784 |
| 2017-07-05 | 1657 |
| 2011-07-02 | 1352 |
| Other values (949) |
| Value | Count | Frequency (%) | |
| 2019-01-05 | 2680 | 5.5% | |
| 2018-12-05 | 2420 | 4.9% | |
| 2015-12-17 | 1784 | 3.6% | |
| 2017-07-05 | 1657 | 3.4% | |
| 2011-07-02 | 1352 | 2.8% | |
| 2014-08-17 | 1266 | 2.6% | |
| 2018-02-05 | 1211 | 2.5% | |
| 2017-01-20 | 1172 | 2.4% | |
| 2016-12-20 | 1141 | 2.3% | |
| 2013-02-05 | 1130 | 2.3% | |
| Other values (944) | 32135 | 65.6% |
Unique
| Unique | 421 ? |
|---|---|
| Unique (%) | 0.9% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.852231432 |
| Min length | 3 |
| Distinct | 2047 |
|---|---|
| Distinct (%) | 4.3% |
| Missing | 990 |
| Missing (%) | 2.0% |
| Memory size | 382.7 KiB |
| 2024-12-05 | 912 |
|---|---|
| 2018-06-05 | 613 |
| 2020-12-05 | 487 |
| 2022-12-05 | 471 |
| 2018-12-20 | 423 |
| Other values (2042) |
| Value | Count | Frequency (%) | |
| 2024-12-05 | 912 | 1.9% | |
| 2018-06-05 | 613 | 1.3% | |
| 2020-12-05 | 487 | 1.0% | |
| 2022-12-05 | 471 | 1.0% | |
| 2018-12-20 | 423 | 0.9% | |
| 2021-12-05 | 396 | 0.8% | |
| 2019-06-05 | 381 | 0.8% | |
| 2020-10-05 | 372 | 0.8% | |
| 2020-07-17 | 368 | 0.8% | |
| 2020-12-20 | 349 | 0.7% | |
| Other values (2037) | 43220 | 88.2% | |
| (Missing) | 990 | 2.0% |
Unique
| Unique | 739 ? |
|---|---|
| Unique (%) | 1.5% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.858519456 |
| Min length | 3 |
| Distinct | 1130 |
|---|---|
| Distinct (%) | 5.6% |
| Missing | 28842 |
| Missing (%) | 58.9% |
| Memory size | 382.7 KiB |
| 2018-10-30 | 475 |
|---|---|
| 2019-02-28 | 350 |
| 2019-09-30 | 192 |
| 2020-09-22 | 189 |
| 2020-08-31 | 163 |
| Other values (1125) |
| Value | Count | Frequency (%) | |
| 2018-10-30 | 475 | 1.0% | |
| 2019-02-28 | 350 | 0.7% | |
| 2019-09-30 | 192 | 0.4% | |
| 2020-09-22 | 189 | 0.4% | |
| 2020-08-31 | 163 | 0.3% | |
| 2019-08-30 | 160 | 0.3% | |
| 2020-09-21 | 145 | 0.3% | |
| 2020-07-31 | 144 | 0.3% | |
| 2020-09-30 | 124 | 0.3% | |
| 2020-02-28 | 118 | 0.2% | |
| Other values (1120) | 18080 | 36.9% | |
| (Missing) | 28842 | 58.9% |
Unique
| Unique | 383 ? |
|---|---|
| Unique (%) | 1.9% |
Length
| Max length | 10 |
|---|---|
| Median length | 3 |
| Mean length | 5.878200155 |
| Min length | 3 |
SALDOINICIAAMORT
Real number (ℝ≥0)
| Distinct | 47896 |
|---|---|
| Distinct (%) | 98.5% |
| Missing | 333 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9538704.363 |
|---|---|
| Minimum | 0 |
| Maximum | 94723156 |
| Zeros | 36 |
| Zeros (%) | 0.1% |
| Memory size | 382.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 954666.42 |
| Q1 | 3414070.93 |
| median | 6896904.01 |
| Q3 | 12806253 |
| 95-th percentile | 26243843.99 |
| Maximum | 94723156 |
| Range | 94723156 |
| Interquartile range (IQR) | 9392182.07 |
Descriptive statistics
| Standard deviation | 9049199.759 |
|---|---|
| Coefficient of variation (CV) | 0.9486822754 |
| Kurtosis | 9.015672172 |
| Mean | 9538704.363 |
| Median Absolute Deviation (MAD) | 4235939.48 |
| Skewness | 2.373503809 |
| Sum | 4.640484286e+11 |
| Variance | 8.188801628e+13 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 36 | 0.1% | |
| 1631753.35 | 22 | < 0.1% | |
| 314883.18 | 20 | < 0.1% | |
| 1732250 | 18 | < 0.1% | |
| 1710663.5 | 14 | < 0.1% | |
| 316713.09 | 8 | < 0.1% | |
| 2042970.97 | 8 | < 0.1% | |
| 1119038.58 | 7 | < 0.1% | |
| 1667732.3 | 7 | < 0.1% | |
| 1247809.59 | 7 | < 0.1% | |
| Other values (47886) | 48502 | 99.0% | |
| (Missing) | 333 | 0.7% |
| Value | Count | Frequency (%) | |
| 0 | 36 | 0.1% | |
| 1038.17 | 1 | < 0.1% | |
| 1179.08 | 1 | < 0.1% | |
| 2318.5 | 1 | < 0.1% | |
| 3658 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 94723156 | 1 | < 0.1% | |
| 93503758.89 | 1 | < 0.1% | |
| 88872006.58 | 1 | < 0.1% | |
| 87144402.49 | 1 | < 0.1% | |
| 86573797 | 1 | < 0.1% |
DEPTORESIDENCIA
Categorical
| Distinct | 36 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 354 |
| Missing (%) | 0.7% |
| Memory size | 382.7 KiB |
| DISTRITO CAPITAL | |
|---|---|
| ATLANTICO | |
| BOLIVAR | |
| VALLE DEL CAUCA | |
| ANTIOQUIA | |
| Other values (31) |
| Value | Count | Frequency (%) | |
| DISTRITO CAPITAL | 8651 | 17.7% | |
| ATLANTICO | 7025 | 14.3% | |
| BOLIVAR | 6616 | 13.5% | |
| VALLE DEL CAUCA | 3419 | 7.0% | |
| ANTIOQUIA | 2612 | 5.3% | |
| SUCRE | 2291 | 4.7% | |
| SANTANDER | 2183 | 4.5% | |
| CORDOBA | 2090 | 4.3% | |
| CUNDINAMARCA | 1768 | 3.6% | |
| MAGDALENA | 1119 | 2.3% | |
| Other values (26) | 10854 | 22.2% |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 18 |
|---|---|
| Median length | 9 |
| Mean length | 9.852292679 |
| Min length | 3 |
| Distinct | 824 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 357 |
| Missing (%) | 0.7% |
| Memory size | 382.7 KiB |
| BOGOTA D.C. | |
|---|---|
| CARTAGENA | |
| BARRANQUILLA | |
| CALI | 2357 |
| MEDELLIN | 1436 |
| Other values (819) |
| Value | Count | Frequency (%) | |
| BOGOTA D.C. | 8468 | 17.3% | |
| CARTAGENA | 5766 | 11.8% | |
| BARRANQUILLA | 5070 | 10.4% | |
| CALI | 2357 | 4.8% | |
| MEDELLIN | 1436 | 2.9% | |
| SINCELEJO | 1363 | 2.8% | |
| SOLEDAD | 1142 | 2.3% | |
| BUCARAMANGA | 988 | 2.0% | |
| MONTERIA | 729 | 1.5% | |
| CUCUTA | 665 | 1.4% | |
| Other values (814) | 20641 | 42.1% |
Unique
| Unique | 163 ? |
|---|---|
| Unique (%) | 0.3% |
Length
| Max length | 25 |
|---|---|
| Median length | 9 |
| Mean length | 9.046853946 |
| Min length | 1 |
| Distinct | 306 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 320 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2532.688422 |
|---|---|
| Minimum | 0 |
| Maximum | 9907 |
| Zeros | 828 |
| Zeros (%) | 1.7% |
| Memory size | 382.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1114.05 |
| Q1 | 1729 |
| median | 1832 |
| Q3 | 2832 |
| 95-th percentile | 4813 |
| Maximum | 9907 |
| Range | 9907 |
| Interquartile range (IQR) | 1103 |
Descriptive statistics
| Standard deviation | 1518.676917 |
|---|---|
| Coefficient of variation (CV) | 0.5996303784 |
| Kurtosis | 8.413529948 |
| Mean | 2532.688422 |
| Median Absolute Deviation (MAD) | 715 |
| Skewness | 2.482437179 |
| Sum | 123245684 |
| Variance | 2306379.578 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 3710 | 2502 | 5.1% | |
| 1832 | 1699 | 3.5% | |
| 2102 | 1360 | 2.8% | |
| 2805 | 1221 | 2.5% | |
| 1804 | 1175 | 2.4% | |
| 2823 | 1148 | 2.3% | |
| 2836 | 1100 | 2.2% | |
| 4813 | 993 | 2.0% | |
| 1805 | 950 | 1.9% | |
| 1818 | 930 | 1.9% | |
| Other values (296) | 35584 | 72.6% |
| Value | Count | Frequency (%) | |
| 0 | 828 | 1.7% | |
| 2 | 329 | 0.7% | |
| 1101 | 149 | 0.3% | |
| 1102 | 76 | 0.2% | |
| 1103 | 47 | 0.1% |
| Value | Count | Frequency (%) | |
| 9907 | 22 | < 0.1% | |
| 9906 | 9 | < 0.1% | |
| 9905 | 15 | < 0.1% | |
| 9904 | 2 | < 0.1% | |
| 9903 | 1 | < 0.1% |
| Distinct | 297 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 1136 |
| Missing (%) | 2.3% |
| Memory size | 382.7 KiB |
| FUNDACION TECNOLOGICA ANTONIO DE AREVALO | 2500 |
|---|---|
| UNIVERSIDAD TECNOLOGICA DE BOLIVAR | 1699 |
| UNIVERSIDAD COOPERATIVA DE COLOMBIA | 1598 |
| UNIVERSIDAD NACIONAL ABIERTA Y A DISTANCIA UNAD | 1360 |
| UNIVERSIDAD SIMON BOLIVAR | 1221 |
| Other values (292) |
| Value | Count | Frequency (%) | |
| FUNDACION TECNOLOGICA ANTONIO DE AREVALO | 2500 | 5.1% | |
| UNIVERSIDAD TECNOLOGICA DE BOLIVAR | 1699 | 3.5% | |
| UNIVERSIDAD COOPERATIVA DE COLOMBIA | 1598 | 3.3% | |
| UNIVERSIDAD NACIONAL ABIERTA Y A DISTANCIA UNAD | 1360 | 2.8% | |
| UNIVERSIDAD SIMON BOLIVAR | 1221 | 2.5% | |
| UNIVERSIDAD LIBRE | 1182 | 2.4% | |
| PA FIDUPREVISORAS A UNIVERSIDAD AUTONOMA DEL CARIBE | 1175 | 2.4% | |
| CORPORACION UNIVERSITARIA DEL CARIBE | 1148 | 2.3% | |
| CORPORACION UNIVERSITARIA EMPRESARIAL DE SALAMANCA | 1100 | 2.2% | |
| CORPORACION UNIFICADA NACIONAL DE EDUCACION SUPERI | 993 | 2.0% | |
| Other values (287) | 33870 | 69.1% | |
| (Missing) | 1136 | 2.3% |
Unique
| Unique | 27 ? |
|---|---|
| Unique (%) | 0.1% |
Length
| Max length | 80 |
|---|---|
| Median length | 35 |
| Mean length | 34.69554122 |
| Min length | 3 |
| Distinct | 2279 |
|---|---|
| Distinct (%) | 4.8% |
| Missing | 1148 |
| Missing (%) | 2.3% |
| Memory size | 382.7 KiB |
| DERECHO | |
|---|---|
| CONTADURIA PUBLICA | 2300 |
| PSICOLOGIA | 2299 |
| ADMINISTRACION DE EMPRESAS | 1897 |
| MEDICINA | 1821 |
| Other values (2274) |
| Value | Count | Frequency (%) | |
| DERECHO | 4326 | 8.8% | |
| CONTADURIA PUBLICA | 2300 | 4.7% | |
| PSICOLOGIA | 2299 | 4.7% | |
| ADMINISTRACION DE EMPRESAS | 1897 | 3.9% | |
| MEDICINA | 1821 | 3.7% | |
| INGENIERIA INDUSTRIAL | 1666 | 3.4% | |
| INGENIERIA DE SISTEMAS | 1191 | 2.4% | |
| TECNOLOGIA EN SALUD OCUPACIONAL | 1110 | 2.3% | |
| INGENIERIA CIVIL | 1046 | 2.1% | |
| ENFERMERIA | 931 | 1.9% | |
| Other values (2269) | 29247 | 59.7% | |
| (Missing) | 1148 | 2.3% |
Unique
| Unique | 898 ? |
|---|---|
| Unique (%) | 1.9% |
Length
| Max length | 100 |
|---|---|
| Median length | 22 |
| Mean length | 25.23867951 |
| Min length | 3 |
NIVELDEFORMACION
Categorical
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 335 |
| Missing (%) | 0.7% |
| Memory size | 382.7 KiB |
| UNIVERSITARIA | |
|---|---|
| TECNOLOGICA TERMINAL | |
| TECNICA PROFESIONAL | 2311 |
| ESPECIALIZACION | 826 |
| MAESTRIA | 642 |
| Other values (9) | 395 |
| Value | Count | Frequency (%) | |
| UNIVERSITARIA | 34155 | 69.7% | |
| TECNOLOGICA TERMINAL | 10318 | 21.1% | |
| TECNICA PROFESIONAL | 2311 | 4.7% | |
| ESPECIALIZACION | 826 | 1.7% | |
| MAESTRIA | 642 | 1.3% | |
| EDUCACION CONTINUADA | 329 | 0.7% | |
| TECNOLOGICA | 26 | 0.1% | |
| DOCTORADO | 22 | < 0.1% | |
| ESPECIALIZACION UNIVERSITARIA | 5 | < 0.1% | |
| ESPECIALIZACION TECNOLOGICA | 4 | < 0.1% | |
| Other values (4) | 9 | < 0.1% | |
| (Missing) | 335 | 0.7% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 33 |
|---|---|
| Median length | 13 |
| Mean length | 14.70660651 |
| Min length | 3 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 319 |
| Missing (%) | 0.7% |
| Memory size | 382.7 KiB |
| ACCES | |
|---|---|
| LINEAS TRADICIONALES |
| Value | Count | Frequency (%) | |
| ACCES | 33891 | 69.2% | |
| LINEAS TRADICIONALES | 14772 | 30.2% | |
| (Missing) | 319 | 0.7% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 20 |
|---|---|
| Median length | 5 |
| Mean length | 9.510677392 |
| Min length | 3 |
TIPOCARTERA
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 319 |
| Missing (%) | 0.7% |
| Memory size | 382.7 KiB |
| AMORTIZACION | |
|---|---|
| ESTUDIOS | 1 |
| Value | Count | Frequency (%) | |
| AMORTIZACION | 48662 | 99.3% | |
| ESTUDIOS | 1 | < 0.1% | |
| (Missing) | 319 | 0.7% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 11.94130497 |
| Min length | 3 |
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2909 |
| Missing (%) | 5.9% |
| Memory size | 382.7 KiB |
| COBRO PREJURIDICO - INGRESO | |
|---|---|
| COBRO PREJURIDICO - DEVOLUCION | |
| COBRO PREJURIDICO CARTERA K - INGRESO | |
| COBRO ADMINISTRATIVO DEVOLUCION | 2465 |
| COBRO ADMINISTRATIVO INGRESO | 2412 |
| Other values (16) | 2195 |
| Value | Count | Frequency (%) | |
| COBRO PREJURIDICO - INGRESO | 29943 | 61.1% | |
| COBRO PREJURIDICO - DEVOLUCION | 5292 | 10.8% | |
| COBRO PREJURIDICO CARTERA K - INGRESO | 3766 | 7.7% | |
| COBRO ADMINISTRATIVO DEVOLUCION | 2465 | 5.0% | |
| COBRO ADMINISTRATIVO INGRESO | 2412 | 4.9% | |
| RETENCION SALARIAL-INGRESO | 1426 | 2.9% | |
| COBRO ADMINISTRATIVO CARTERA K -DEVOLUCION | 215 | 0.4% | |
| COBRO ADMINISTRATIVO CARTERA K - INGRESO | 211 | 0.4% | |
| RETENCION SALARIAL-DEVOLUCION | 121 | 0.2% | |
| COBRO PREJURIDICO CARTERA K - DEVOLUCION | 108 | 0.2% | |
| Other values (11) | 114 | 0.2% | |
| (Missing) | 2909 | 5.9% |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 46 |
|---|---|
| Median length | 27 |
| Mean length | 27.02080356 |
| Min length | 3 |
| Distinct | 48004 |
|---|---|
| Distinct (%) | 98.7% |
| Missing | 365 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7029252.595 |
|---|---|
| Minimum | -2498131.23 |
| Maximum | 94723156 |
| Zeros | 175 |
| Zeros (%) | 0.4% |
| Memory size | 382.7 KiB |
Quantile statistics
| Minimum | -2498131.23 |
|---|---|
| 5-th percentile | 364692.828 |
| Q1 | 2037374.15 |
| median | 4635403.81 |
| Q3 | 9149828.36 |
| 95-th percentile | 21775178.55 |
| Maximum | 94723156 |
| Range | 97221287.23 |
| Interquartile range (IQR) | 7112454.21 |
Descriptive statistics
| Standard deviation | 7814236.6 |
|---|---|
| Coefficient of variation (CV) | 1.111673893 |
| Kurtosis | 12.49686312 |
| Mean | 7029252.595 |
| Median Absolute Deviation (MAD) | 3092016.13 |
| Skewness | 2.811419267 |
| Sum | 3.417411734e+11 |
| Variance | 6.106229365e+13 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 175 | 0.4% | |
| 941040 | 23 | < 0.1% | |
| 946508.75 | 8 | < 0.1% | |
| 2852679 | 7 | < 0.1% | |
| 2173494.5 | 7 | < 0.1% | |
| 2696480.01 | 7 | < 0.1% | |
| 2633333.17 | 7 | < 0.1% | |
| 1247809.59 | 7 | < 0.1% | |
| 939552 | 7 | < 0.1% | |
| 2233447.98 | 7 | < 0.1% | |
| Other values (47994) | 48362 | 98.7% | |
| (Missing) | 365 | 0.7% |
| Value | Count | Frequency (%) | |
| -2498131.23 | 1 | < 0.1% | |
| -467789 | 1 | < 0.1% | |
| -383681 | 1 | < 0.1% | |
| -316679 | 1 | < 0.1% | |
| -233333.93 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 94723156 | 1 | < 0.1% | |
| 93503758.89 | 1 | < 0.1% | |
| 88330116.58 | 1 | < 0.1% | |
| 87882838 | 1 | < 0.1% | |
| 86362867.72 | 1 | < 0.1% |
| Distinct | 44386 |
|---|---|
| Distinct (%) | 91.2% |
| Missing | 319 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6734558.451 |
|---|---|
| Minimum | -2498131.23 |
| Maximum | 94723155.76 |
| Zeros | 3863 |
| Zeros (%) | 7.9% |
| Memory size | 382.7 KiB |
Quantile statistics
| Minimum | -2498131.23 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1642084.765 |
| median | 4384667 |
| Q3 | 8933521.23 |
| 95-th percentile | 21523460.92 |
| Maximum | 94723155.76 |
| Range | 97221286.99 |
| Interquartile range (IQR) | 7291436.465 |
Descriptive statistics
| Standard deviation | 7869618.489 |
|---|---|
| Coefficient of variation (CV) | 1.168542607 |
| Kurtosis | 12.21843224 |
| Mean | 6734558.451 |
| Median Absolute Deviation (MAD) | 3257906.2 |
| Skewness | 2.767087601 |
| Sum | 3.277238179e+11 |
| Variance | 6.193089516e+13 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 3863 | 7.9% | |
| 941040 | 22 | < 0.1% | |
| 946508.75 | 8 | < 0.1% | |
| 2696480.01 | 7 | < 0.1% | |
| 2852679 | 7 | < 0.1% | |
| 939552 | 7 | < 0.1% | |
| 2173494.5 | 7 | < 0.1% | |
| 2633333.17 | 7 | < 0.1% | |
| 1247809.59 | 7 | < 0.1% | |
| 2233447.98 | 7 | < 0.1% | |
| Other values (44376) | 44721 | 91.3% | |
| (Missing) | 319 | 0.7% |
| Value | Count | Frequency (%) | |
| -2498131.23 | 1 | < 0.1% | |
| -2174006.96 | 1 | < 0.1% | |
| -681144.3 | 1 | < 0.1% | |
| -597070 | 1 | < 0.1% | |
| -590530.89 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 94723155.76 | 1 | < 0.1% | |
| 93503758.89 | 1 | < 0.1% | |
| 88330116.58 | 1 | < 0.1% | |
| 87882838.4 | 1 | < 0.1% | |
| 86362867.72 | 1 | < 0.1% |
| Distinct | 74 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 319 |
| Missing (%) | 0.7% |
| Memory size | 382.7 KiB |
| ACCES | |
|---|---|
| ALIANZA | |
| PREGRADO MP | |
| CERES | |
| TU ELIGES 25% | |
| Other values (69) |
| Value | Count | Frequency (%) | |
| ACCES | 22816 | 46.6% | |
| ALIANZA | 8001 | 16.3% | |
| PREGRADO MP | 5112 | 10.4% | |
| CERES | 2793 | 5.7% | |
| TU ELIGES 25% | 2539 | 5.2% | |
| PREGRADO LARGO PLAZO | 938 | 1.9% | |
| POSGRADO PAIS CON DEUDOR | 581 | 1.2% | |
| PREGRADO MP 50-50 | 555 | 1.1% | |
| TU ELIGES 50% | 468 | 1.0% | |
| POSGRADO PAIS SIN DEUDOR | 450 | 0.9% | |
| Other values (64) | 4410 | 9.0% |
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 49 |
|---|---|
| Median length | 5 |
| Mean length | 8.577518272 |
| Min length | 3 |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3002 |
| Missing (%) | 6.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.845867769 |
|---|---|
| Minimum | 0 |
| Maximum | 6 |
| Zeros | 428 |
| Zeros (%) | 0.9% |
| Memory size | 382.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.8805006701 |
|---|---|
| Coefficient of variation (CV) | 0.4770117801 |
| Kurtosis | 1.378626055 |
| Mean | 1.845867769 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.9315836994 |
| Sum | 84873 |
| Variance | 0.7752814301 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2 | 18571 | 37.9% | |
| 1 | 17718 | 36.2% | |
| 3 | 7617 | 15.6% | |
| 4 | 1177 | 2.4% | |
| 0 | 428 | 0.9% | |
| 5 | 360 | 0.7% | |
| 6 | 109 | 0.2% | |
| (Missing) | 3002 | 6.1% |
| Value | Count | Frequency (%) | |
| 0 | 428 | 0.9% | |
| 1 | 17718 | 36.2% | |
| 2 | 18571 | 37.9% | |
| 3 | 7617 | 15.6% | |
| 4 | 1177 | 2.4% |
| Value | Count | Frequency (%) | |
| 6 | 109 | 0.2% | |
| 5 | 360 | 0.7% | |
| 4 | 1177 | 2.4% | |
| 3 | 7617 | 15.6% | |
| 2 | 18571 | 37.9% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3123 |
| Missing (%) | 6.4% |
| Memory size | 382.7 KiB |
| F | |
|---|---|
| M |
| Value | Count | Frequency (%) | |
| F | 24180 | 49.4% | |
| M | 21679 | 44.3% | |
| (Missing) | 3123 | 6.4% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.12751623 |
| Min length | 1 |
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2964 |
| Missing (%) | 6.1% |
| Memory size | 382.7 KiB |
| SOLTERO(A) | |
|---|---|
| CASADO(A) | |
| OTRO | 2350 |
| 1 | 803 |
| UNIËN LIBRE | 502 |
| Other values (7) | 478 |
| Value | Count | Frequency (%) | |
| SOLTERO(A) | 37885 | 77.3% | |
| CASADO(A) | 4000 | 8.2% | |
| OTRO | 2350 | 4.8% | |
| 1 | 803 | 1.6% | |
| UNIËN LIBRE | 502 | 1.0% | |
| DIVORCIADO(A) / SEPARADO(A) | 271 | 0.6% | |
| 2 | 90 | 0.2% | |
| UNIÓN LIBRE | 47 | 0.1% | |
| 3 | 44 | 0.1% | |
| VIUDO(A) | 12 | < 0.1% | |
| Other values (2) | 14 | < 0.1% | |
| (Missing) | 2964 | 6.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 27 |
|---|---|
| Median length | 10 |
| Mean length | 9.136927851 |
| Min length | 1 |
TIPONOVEDAD
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 9 |
| Missing (%) | < 0.1% |
| Memory size | 382.7 KiB |
| N | |
|---|---|
| E | |
| M | 1 |
| Value | Count | Frequency (%) | |
| N | 37719 | 77.0% | |
| E | 11253 | 23.0% | |
| M | 1 | < 0.1% | |
| (Missing) | 9 | < 0.1% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.000367482 |
| Min length | 1 |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 12305 |
| Missing (%) | 25.1% |
| Memory size | 382.7 KiB |
| (10) > 360 | |
|---|---|
| (08) 181 - 270 | 1927 |
| (09) 271 - 360 | 1341 |
| (02) 1 - 30 | 916 |
| (03) 31 - 60 | 719 |
| Other values (4) | 1443 |
| Value | Count | Frequency (%) | |
| (10) > 360 | 30331 | 61.9% | |
| (08) 181 - 270 | 1927 | 3.9% | |
| (09) 271 - 360 | 1341 | 2.7% | |
| (02) 1 - 30 | 916 | 1.9% | |
| (03) 31 - 60 | 719 | 1.5% | |
| (04) 61 - 90 | 568 | 1.2% | |
| (06) 121 - 150 | 337 | 0.7% | |
| (05) 91 - 120 | 328 | 0.7% | |
| (07) 151 - 180 | 210 | 0.4% | |
| (Missing) | 12305 | 25.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 14 |
|---|---|
| Median length | 10 |
| Mean length | 8.644379568 |
| Min length | 3 |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 14625 |
| Missing (%) | 29.9% |
| Memory size | 382.7 KiB |
| MILLENNIALS | |
|---|---|
| GENERACIÓN X | 2979 |
| BABY BOOMERS | 285 |
| GENERACIÓN Z | 192 |
| GENERACIÓN SILENCIOSA | 1 |
| Value | Count | Frequency (%) | |
| MILLENNIALS | 30900 | 63.1% | |
| GENERACIÓN X | 2979 | 6.1% | |
| BABY BOOMERS | 285 | 0.6% | |
| GENERACIÓN Z | 192 | 0.4% | |
| GENERACIÓN SILENCIOSA | 1 | < 0.1% | |
| (Missing) | 14625 | 29.9% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 21 |
|---|---|
| Median length | 11 |
| Mean length | 8.682128129 |
| Min length | 3 |
| Distinct | 1423 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 15306 |
| Missing (%) | 31.2% |
| Memory size | 382.7 KiB |
| 2017-06-30 | 195 |
|---|---|
| 2019-09-10 | 154 |
| 2016-07-12 | 154 |
| 2017-09-05 | 146 |
| 2019-08-05 | 142 |
| Other values (1418) |
| Value | Count | Frequency (%) | |
| 2017-06-30 | 195 | 0.4% | |
| 2019-09-10 | 154 | 0.3% | |
| 2016-07-12 | 154 | 0.3% | |
| 2017-09-05 | 146 | 0.3% | |
| 2019-08-05 | 142 | 0.3% | |
| 2016-09-12 | 138 | 0.3% | |
| 2018-08-10 | 137 | 0.3% | |
| 2019-08-10 | 136 | 0.3% | |
| 2018-09-10 | 133 | 0.3% | |
| 2019-07-05 | 132 | 0.3% | |
| Other values (1413) | 32209 | 65.8% | |
| (Missing) | 15306 | 31.2% |
Unique
| Unique | 85 ? |
|---|---|
| Unique (%) | 0.3% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 7.812625046 |
| Min length | 3 |
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 15306 |
| Missing (%) | 31.2% |
| Memory size | 382.7 KiB |
| INCUMPLIDO | |
|---|---|
| CUMPLIDO | |
| ANULADO | |
| APROBADO | 229 |
| APROBADO EXCEPC | 19 |
| Value | Count | Frequency (%) | |
| INCUMPLIDO | 14426 | 29.5% | |
| CUMPLIDO | 14318 | 29.2% | |
| ANULADO | 4683 | 9.6% | |
| APROBADO | 229 | 0.5% | |
| APROBADO EXCEPC | 19 | < 0.1% | |
| O | 1 | < 0.1% | |
| (Missing) | 15306 | 31.2% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 15 |
|---|---|
| Median length | 8 |
| Mean length | 6.933587849 |
| Min length | 1 |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 15306 |
| Missing (%) | 31.2% |
| Memory size | 382.7 KiB |
| REFINANCIACION | |
|---|---|
| ABONO | |
| NORMALIZACION | |
| EXTINCION | |
| ABONOPV | |
| Other values (2) | 174 |
| Value | Count | Frequency (%) | |
| REFINANCIACION | 13940 | 28.5% | |
| ABONO | 6803 | 13.9% | |
| NORMALIZACION | 6233 | 12.7% | |
| EXTINCION | 4040 | 8.2% | |
| ABONOPV | 2486 | 5.1% | |
| ABONOPT | 173 | 0.4% | |
| AMORTIZACION | 1 | < 0.1% | |
| (Missing) | 15306 | 31.2% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 14 |
|---|---|
| Median length | 7 |
| Mean length | 8.393021926 |
| Min length | 3 |
| Distinct | 34 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 23473 |
| Missing (%) | 47.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.7095142891 |
|---|---|
| Minimum | 0 |
| Maximum | 36 |
| Zeros | 14348 |
| Zeros (%) | 29.3% |
| Memory size | 382.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 36 |
| Range | 36 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 2.183946274 |
|---|---|
| Coefficient of variation (CV) | 3.078086387 |
| Kurtosis | 118.1374431 |
| Mean | 0.7095142891 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 9.772485416 |
| Sum | 18099 |
| Variance | 4.76962133 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 14348 | 29.3% | |
| 1 | 10127 | 20.7% | |
| 2 | 255 | 0.5% | |
| 3 | 160 | 0.3% | |
| 4 | 112 | 0.2% | |
| 6 | 76 | 0.2% | |
| 5 | 68 | 0.1% | |
| 7 | 47 | 0.1% | |
| 24 | 45 | 0.1% | |
| 9 | 35 | 0.1% | |
| Other values (24) | 236 | 0.5% | |
| (Missing) | 23473 | 47.9% |
| Value | Count | Frequency (%) | |
| 0 | 14348 | 29.3% | |
| 1 | 10127 | 20.7% | |
| 2 | 255 | 0.5% | |
| 3 | 160 | 0.3% | |
| 4 | 112 | 0.2% |
| Value | Count | Frequency (%) | |
| 36 | 20 | < 0.1% | |
| 35 | 1 | < 0.1% | |
| 34 | 5 | < 0.1% | |
| 33 | 2 | < 0.1% | |
| 32 | 2 | < 0.1% |
| Distinct | 43 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 23473 |
| Missing (%) | 47.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.556940688 |
|---|---|
| Minimum | 0 |
| Maximum | 47 |
| Zeros | 12558 |
| Zeros (%) | 25.6% |
| Memory size | 382.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 9 |
| Maximum | 47 |
| Range | 47 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 4.456137809 |
|---|---|
| Coefficient of variation (CV) | 2.862111476 |
| Kurtosis | 25.81324986 |
| Mean | 1.556940688 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 4.848328713 |
| Sum | 39716 |
| Variance | 19.85716417 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 12558 | 25.6% | |
| 1 | 10421 | 21.3% | |
| 2 | 436 | 0.9% | |
| 3 | 230 | 0.5% | |
| 12 | 178 | 0.4% | |
| 24 | 165 | 0.3% | |
| 6 | 165 | 0.3% | |
| 18 | 138 | 0.3% | |
| 5 | 136 | 0.3% | |
| 4 | 123 | 0.3% | |
| Other values (33) | 959 | 2.0% | |
| (Missing) | 23473 | 47.9% |
| Value | Count | Frequency (%) | |
| 0 | 12558 | 25.6% | |
| 1 | 10421 | 21.3% | |
| 2 | 436 | 0.9% | |
| 3 | 230 | 0.5% | |
| 4 | 123 | 0.3% |
| Value | Count | Frequency (%) | |
| 47 | 1 | < 0.1% | |
| 42 | 2 | < 0.1% | |
| 41 | 3 | < 0.1% | |
| 40 | 1 | < 0.1% | |
| 39 | 2 | < 0.1% |
| Distinct | 60 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 23473 |
| Missing (%) | 47.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2872319573 |
|---|---|
| Minimum | 0 |
| Maximum | 173 |
| Zeros | 25087 |
| Zeros (%) | 51.2% |
| Memory size | 382.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 173 |
| Range | 173 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 4.572231656 |
|---|---|
| Coefficient of variation (CV) | 15.9182554 |
| Kurtosis | 527.0918458 |
| Mean | 0.2872319573 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 21.17064286 |
| Sum | 7327 |
| Variance | 20.90530231 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 25087 | 51.2% | |
| 1 | 269 | 0.5% | |
| 55 | 12 | < 0.1% | |
| 36 | 11 | < 0.1% | |
| 2 | 11 | < 0.1% | |
| 3 | 9 | < 0.1% | |
| 35 | 7 | < 0.1% | |
| 4 | 7 | < 0.1% | |
| 54 | 5 | < 0.1% | |
| 42 | 4 | < 0.1% | |
| Other values (50) | 87 | 0.2% | |
| (Missing) | 23473 | 47.9% |
| Value | Count | Frequency (%) | |
| 0 | 25087 | 51.2% | |
| 1 | 269 | 0.5% | |
| 2 | 11 | < 0.1% | |
| 3 | 9 | < 0.1% | |
| 4 | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 173 | 1 | < 0.1% | |
| 155 | 1 | < 0.1% | |
| 145 | 1 | < 0.1% | |
| 138 | 1 | < 0.1% | |
| 135 | 2 | < 0.1% |
| Distinct | 103 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 33410 |
| Missing (%) | 68.2% |
| Memory size | 382.7 KiB |
| 2020-02-20 | |
|---|---|
| 2020-05-02 | |
| 2020-02-17 | |
| 2020-10-02 | |
| 2020-03-02 | 234 |
| Other values (98) |
| Value | Count | Frequency (%) | |
| 2020-02-20 | 5441 | 11.1% | |
| 2020-05-02 | 4913 | 10.0% | |
| 2020-02-17 | 2329 | 4.8% | |
| 2020-10-02 | 1394 | 2.8% | |
| 2020-03-02 | 234 | 0.5% | |
| 2020-01-28 | 227 | 0.5% | |
| 2020-01-30 | 165 | 0.3% | |
| 2020-01-31 | 89 | 0.2% | |
| 2020-05-03 | 79 | 0.2% | |
| 2020-03-20 | 66 | 0.1% | |
| Other values (93) | 635 | 1.3% | |
| (Missing) | 33410 | 68.2% |
Unique
| Unique | 47 ? |
|---|---|
| Unique (%) | 0.3% |
Length
| Max length | 10 |
|---|---|
| Median length | 3 |
| Mean length | 5.225388918 |
| Min length | 3 |
| Distinct | 6843 |
|---|---|
| Distinct (%) | 20.3% |
| Missing | 15306 |
| Missing (%) | 31.2% |
| Memory size | 382.7 KiB |
| 0 | |
|---|---|
| 335106 | 3 |
| 599851 | 3 |
| 116905 | 3 |
| 52930 | 3 |
| Other values (6838) |
| Value | Count | Frequency (%) | |
| 0 | 26746 | 54.6% | |
| 335106 | 3 | < 0.1% | |
| 599851 | 3 | < 0.1% | |
| 116905 | 3 | < 0.1% | |
| 52930 | 3 | < 0.1% | |
| 160354,16 | 3 | < 0.1% | |
| 56537 | 2 | < 0.1% | |
| 104743 | 2 | < 0.1% | |
| 53031 | 2 | < 0.1% | |
| 138921 | 2 | < 0.1% | |
| Other values (6833) | 6907 | 14.1% | |
| (Missing) | 15306 | 31.2% |
Unique
| Unique | 6759 ? |
|---|---|
| Unique (%) | 20.1% |
Length
| Max length | 9 |
|---|---|
| Median length | 1 |
| Mean length | 2.306704504 |
| Min length | 1 |
| Distinct | 32 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 15306 |
| Missing (%) | 31.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.434047987 |
|---|---|
| Minimum | 1 |
| Maximum | 46 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 382.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 9 |
| Maximum | 46 |
| Range | 45 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.860770791 |
|---|---|
| Coefficient of variation (CV) | 0.8330608082 |
| Kurtosis | 9.723459991 |
| Mean | 3.434047987 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 2.299368377 |
| Sum | 115645 |
| Variance | 8.18400952 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 9464 | 19.3% | |
| 2 | 6852 | 14.0% | |
| 3 | 5132 | 10.5% | |
| 4 | 3711 | 7.6% | |
| 5 | 2662 | 5.4% | |
| 6 | 1835 | 3.7% | |
| 7 | 1221 | 2.5% | |
| 8 | 865 | 1.8% | |
| 9 | 578 | 1.2% | |
| 10 | 377 | 0.8% | |
| Other values (22) | 979 | 2.0% | |
| (Missing) | 15306 | 31.2% |
| Value | Count | Frequency (%) | |
| 1 | 9464 | 19.3% | |
| 2 | 6852 | 14.0% | |
| 3 | 5132 | 10.5% | |
| 4 | 3711 | 7.6% | |
| 5 | 2662 | 5.4% |
| Value | Count | Frequency (%) | |
| 46 | 1 | < 0.1% | |
| 39 | 1 | < 0.1% | |
| 31 | 2 | < 0.1% | |
| 30 | 1 | < 0.1% | |
| 29 | 3 | < 0.1% |
| Distinct | 19241 |
|---|---|
| Distinct (%) | 61.9% |
| Missing | 17908 |
| Missing (%) | 36.6% |
| Memory size | 382.7 KiB |
| CORPORACION UNIVERSITARIA DEL CARIBE, CECAR. | 198 |
|---|---|
| REGISTRADURIA NACIONAL DEL ESTADO CIVIL | 186 |
| COMFENALCO | 142 |
| UNIVERSIDAD COOPERATIVA DE COLOMBIA | 140 |
| UNIVERSIDAD SIMON BOLIVAR | 135 |
| Other values (19236) |
| Value | Count | Frequency (%) | |
| CORPORACION UNIVERSITARIA DEL CARIBE, CECAR. | 198 | 0.4% | |
| REGISTRADURIA NACIONAL DEL ESTADO CIVIL | 186 | 0.4% | |
| COMFENALCO | 142 | 0.3% | |
| UNIVERSIDAD COOPERATIVA DE COLOMBIA | 140 | 0.3% | |
| UNIVERSIDAD SIMON BOLIVAR | 135 | 0.3% | |
| S E N A | 131 | 0.3% | |
| ACTIVOS SAS | 115 | 0.2% | |
| TELEPERFORMANCE COLOMBIA S A S | 107 | 0.2% | |
| ALMACENES EXITO S A | 106 | 0.2% | |
| CAJA COLOMBIANA DE SUBSIDIO FAMILIAR COLSUBSI | 100 | 0.2% | |
| Other values (19231) | 29714 | 60.7% | |
| (Missing) | 17908 | 36.6% |
Unique
| Unique | 16550 ? |
|---|---|
| Unique (%) | 53.3% |
Length
| Max length | 180 |
|---|---|
| Median length | 18 |
| Mean length | 18.47701196 |
| Min length | 3 |
| Distinct | 174 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 14172 |
| Missing (%) | 28.9% |
| Memory size | 382.7 KiB |
| 2020-10 | |
|---|---|
| 2020-09 | |
| 1900-01 | |
| 2020-08 | 1487 |
| 2019-12 | 747 |
| Other values (169) |
| Value | Count | Frequency (%) | |
| 2020-10 | 8670 | 17.7% | |
| 2020-09 | 4482 | 9.2% | |
| 1900-01 | 3736 | 7.6% | |
| 2020-08 | 1487 | 3.0% | |
| 2019-12 | 747 | 1.5% | |
| 2019-11 | 670 | 1.4% | |
| 2020-07 | 633 | 1.3% | |
| 2020-01 | 632 | 1.3% | |
| 2020-04 | 630 | 1.3% | |
| 2020-06 | 541 | 1.1% | |
| Other values (164) | 12582 | 25.7% | |
| (Missing) | 14172 | 28.9% |
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 5.842676902 |
| Min length | 3 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 14172 |
| Missing (%) | 28.9% |
| Memory size | 382.7 KiB |
| 2020-10-01 |
|---|
| Value | Count | Frequency (%) | |
| 2020-10-01 | 34810 | 71.1% | |
| (Missing) | 14172 | 28.9% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 7.974684578 |
| Min length | 3 |
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 20802 |
| Missing (%) | 42.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.10809084 |
|---|---|
| Minimum | 7 |
| Maximum | 20 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 382.7 KiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 9 |
| median | 11 |
| Q3 | 13 |
| 95-th percentile | 16 |
| Maximum | 20 |
| Range | 13 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.80992772 |
|---|---|
| Coefficient of variation (CV) | 0.252962256 |
| Kurtosis | -0.3780261183 |
| Mean | 11.10809084 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.6365925316 |
| Sum | 313026 |
| Variance | 7.895693789 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 9 | 4595 | 9.4% | |
| 8 | 4278 | 8.7% | |
| 10 | 3748 | 7.7% | |
| 11 | 3217 | 6.6% | |
| 12 | 2711 | 5.5% | |
| 13 | 2219 | 4.5% | |
| 15 | 1913 | 3.9% | |
| 14 | 1866 | 3.8% | |
| 7 | 1302 | 2.7% | |
| 16 | 1230 | 2.5% | |
| Other values (4) | 1101 | 2.2% | |
| (Missing) | 20802 | 42.5% |
| Value | Count | Frequency (%) | |
| 7 | 1302 | 2.7% | |
| 8 | 4278 | 8.7% | |
| 9 | 4595 | 9.4% | |
| 10 | 3748 | 7.7% | |
| 11 | 3217 | 6.6% |
| Value | Count | Frequency (%) | |
| 20 | 21 | < 0.1% | |
| 19 | 268 | 0.5% | |
| 18 | 272 | 0.6% | |
| 17 | 540 | 1.1% | |
| 16 | 1230 | 2.5% |
| Distinct | 38 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 11236 |
| Missing (%) | 22.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.026439888 |
|---|---|
| Minimum | 1 |
| Maximum | 48 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 382.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 10 |
| Maximum | 48 |
| Range | 47 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 3.179379569 |
|---|---|
| Coefficient of variation (CV) | 0.7896254899 |
| Kurtosis | 7.900779322 |
| Mean | 4.026439888 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 1.999249804 |
| Sum | 151982 |
| Variance | 10.10845444 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 8108 | 16.6% | |
| 2 | 6831 | 13.9% | |
| 3 | 5703 | 11.6% | |
| 4 | 4494 | 9.2% | |
| 5 | 3466 | 7.1% | |
| 6 | 2538 | 5.2% | |
| 7 | 1873 | 3.8% | |
| 8 | 1452 | 3.0% | |
| 9 | 940 | 1.9% | |
| 10 | 686 | 1.4% | |
| Other values (28) | 1655 | 3.4% | |
| (Missing) | 11236 | 22.9% |
| Value | Count | Frequency (%) | |
| 1 | 8108 | 16.6% | |
| 2 | 6831 | 13.9% | |
| 3 | 5703 | 11.6% | |
| 4 | 4494 | 9.2% | |
| 5 | 3466 | 7.1% |
| Value | Count | Frequency (%) | |
| 48 | 1 | < 0.1% | |
| 43 | 1 | < 0.1% | |
| 41 | 1 | < 0.1% | |
| 36 | 1 | < 0.1% | |
| 34 | 2 | < 0.1% |
| Distinct | 99 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 3240 |
| Missing (%) | 6.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.02476936 |
|---|---|
| Minimum | 1 |
| Maximum | 164 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 382.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 6 |
| median | 12 |
| Q3 | 21 |
| 95-th percentile | 38 |
| Maximum | 164 |
| Range | 163 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 11.99213699 |
|---|---|
| Coefficient of variation (CV) | 0.7981578086 |
| Kurtosis | 3.429694931 |
| Mean | 15.02476936 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 1.425010291 |
| Sum | 687263 |
| Variance | 143.8113495 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 2175 | 4.4% | |
| 4 | 2148 | 4.4% | |
| 3 | 2138 | 4.4% | |
| 2 | 2093 | 4.3% | |
| 5 | 2080 | 4.2% | |
| 7 | 2048 | 4.2% | |
| 6 | 2042 | 4.2% | |
| 8 | 1947 | 4.0% | |
| 9 | 1833 | 3.7% | |
| 10 | 1765 | 3.6% | |
| Other values (89) | 25473 | 52.0% | |
| (Missing) | 3240 | 6.6% |
| Value | Count | Frequency (%) | |
| 1 | 2175 | 4.4% | |
| 2 | 2093 | 4.3% | |
| 3 | 2138 | 4.4% | |
| 4 | 2148 | 4.4% | |
| 5 | 2080 | 4.2% |
| Value | Count | Frequency (%) | |
| 164 | 1 | < 0.1% | |
| 133 | 1 | < 0.1% | |
| 132 | 1 | < 0.1% | |
| 118 | 1 | < 0.1% | |
| 116 | 1 | < 0.1% |
| Distinct | 92 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 2524 |
| Missing (%) | 5.2% |
| Memory size | 382.7 KiB |
| NO EFECTIVO_NO LO CONOCEN_NAN_NAN | |
|---|---|
| NO CONTACTADO_NO CONTESTA_NAN_NAN | |
| NO CONTACTADO_BUZON_NAN_NAN | |
| NO EFECTIVO_MENSAJE CON TERCERO_NAN_NAN | |
| EFECTIVO_COMPROMISO DE PAGO_NAN_NAN | 1762 |
| Other values (87) |
| Value | Count | Frequency (%) | |
| NO EFECTIVO_NO LO CONOCEN_NAN_NAN | 9923 | 20.3% | |
| NO CONTACTADO_NO CONTESTA_NAN_NAN | 7730 | 15.8% | |
| NO CONTACTADO_BUZON_NAN_NAN | 5738 | 11.7% | |
| NO EFECTIVO_MENSAJE CON TERCERO_NAN_NAN | 3468 | 7.1% | |
| EFECTIVO_COMPROMISO DE PAGO_NAN_NAN | 1762 | 3.6% | |
| OTROS_CAIDA_NAN_NAN | 1751 | 3.6% | |
| EFECTIVO_NO REALIZA PAGO_RENUENTE_NAN | 1702 | 3.5% | |
| EFECTIVO_NO REALIZA PAGO_INSOLVENTE_NAN | 1633 | 3.3% | |
| EFECTIVO_CR DITO ADMINISTRATIVO_NAN_NAN | 1193 | 2.4% | |
| EFECTIVO_PROGRAMACI N DE LLAMADA_NAN_NAN | 1122 | 2.3% | |
| Other values (82) | 10436 | 21.3% | |
| (Missing) | 2524 | 5.2% |
Unique
| Unique | 12 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 81 |
|---|---|
| Median length | 33 |
| Mean length | 33.85143522 |
| Min length | 3 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| IDSOLICITUD | FECHAENTRADA | FECHASALIDA | FECHAACTUALIZACION | FECHAMORADESDE | NROCUOTASMORA | NUMDIASMORA_ACT | VALORCUOTA | SALDOTOTALMORA1_ACT | SALDOTOTAL_ACT | FECHAMOVIMIENTO | CALIFICACIONACTUAL | VCTO_CUOTA1 | FECHA_VCTO | FECHAULTPAGO | SALDOINICIAAMORT | DEPTORESIDENCIA | MUNICRESIDENCIA | CODSNIES_INST | IES | NOMBREPROGRAMA | NIVELDEFORMACION | LINEA | TIPOCARTERA | ESTADOACTUAL | SALDOCAPITALACIERRE | CAPITALICETEX_ACT | SUBLINEA | ESTRATO | SEXO | ESTADOCIVIL | TIPONOVEDAD | Rangodiasmora | CONCEPTO | FECHA_ACUERDO | ESTADO_ACUERDO | TIPO_ACUERDO | CUOTAS_PAGADAS_ACUERDO | CUOTAS_MORA_ACUERDO | CUOTAS_FUTURAS_ACUERDO | fecha Venc Cuota Vigente | Valor Cuota Vigente | No. ACUERDOS DE PAGO | RazonSocial | UltimoPeriodoCotizado | FechaFosyga | Hora_ContactoEfectivo | Llamadas_recibidas | Llamadas_realizadas | Tipificacion | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 280 | 2020-11-17 | NaN | 2020-11-17 | NaN | 0.0 | 6.0 | 218384.59 | 231102.87 | 4248178.84 | 2020-11-17 | K | 2010-01-31 | 2022-06-10 | 2020-10-15 | 27788677.09 | VALLE DEL CAUCA | ZARZAL | 1834.0 | UNIVERSIDAD DEL SINU Elias Bechara Zainum - UNISIN | MEDICINA | UNIVERSITARIA | ACCES | AMORTIZACION | COBRO ADMINISTRATIVO DEVOLUCION | 4001850.62 | 4001850.62 | ACCES | 1.0 | F | SOLTERO(A) | N | NaN | NaN | 2017-09-22 | INCUMPLIDO | NORMALIZACION | 0.0 | 1.0 | 0.0 | 2020-10-02 | 287094 | 3.0 | NaN | NaN | NaN | NaN | 1.0 | 1.0 | NO CONTACTADO_BUZON_NAN_NAN |
| 1 | 372 | 2020-11-10 | 2020-11-17 | 2020-11-17 | NaN | 0.0 | 0.0 | 145209.36 | 0.00 | 11004369.72 | 2020-11-17 | K | 2018-12-03 | 2026-08-03 | 2020-10-10 | 15310906.24 | DISTRITO CAPITAL | BOGOTA D.C. | 2825.0 | CORPORACION UNIVERSITARIA RAFAEL NUNEZ | BACTERIOLOGIA | UNIVERSITARIA | ACCES | AMORTIZACION | COBRO ADMINISTRATIVO DEVOLUCION | 9102814.62 | 8985988.33 | ACCES | 1.0 | F | SOLTERO(A) | E | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 9.0 | EFECTIVO_REALIZA ACUERDO DE PAGO_ABONO PAGO VENCIDO_NAN |
| 2 | 1132 | 2020-11-10 | 2020-11-17 | 2020-11-17 | NaN | 0.0 | 11.0 | 167036.95 | 269.36 | 6514205.03 | 2020-11-17 | K | 2011-07-02 | 2024-04-05 | 2020-10-02 | 19772924.31 | VALLE DEL CAUCA | CALI | 1805.0 | UNIVERSIDAD SANTIAGO DE CALI | DERECHO | UNIVERSITARIA | ACCES | AMORTIZACION | COBRO PREJURIDICO - INGRESO | 6566208.21 | 6422071.95 | ACCES | 2.0 | F | SOLTERO(A) | E | NaN | NaN | 2019-05-08 | INCUMPLIDO | ABONO | 0.0 | 1.0 | 0.0 | 2020-02-20 | 0 | 8.0 | NaN | NaN | NaN | 7.0 | 10.0 | 30.0 | EFECTIVO_YA PAGO_PENDIENTE CONDONACI N_NAN |
| 3 | 3518 | 2020-11-01 | 2020-11-17 | 2020-11-17 | 2020-03-05 | 7.0 | 0.0 | 186526.37 | 0.00 | 1187551.21 | 2020-11-17 | K | 2009-11-30 | 2020-10-05 | 2020-09-29 | 9226473.98 | CUNDINAMARCA | NEMOCON | 1729.0 | UNIVERSIDAD EL BOSQUE | LICENCIATURA EN PEDAGOGIA INFANTIL | UNIVERSITARIA | ACCES | AMORTIZACION | COBRO PREJURIDICO - INGRESO | 1367000.12 | 1084521.26 | ACCES | 2.0 | F | SOLTERO(A) | E | NaN | NaN | 2020-08-28 | CUMPLIDO | REFINANCIACION | NaN | NaN | NaN | NaN | 0 | 6.0 | NaN | NaN | NaN | 10.0 | 12.0 | 25.0 | EFECTIVO_CR DITOS NO ASIGNADOS_INFORMACI N GENERAL_NAN |
| 4 | 5648 | 2020-11-17 | NaN | 2020-11-17 | 2020-10-10 | 1.0 | 6.0 | 331863.91 | 223180.79 | 2155653.88 | 2020-11-17 | K | 2010-09-30 | 2021-05-10 | 2020-10-02 | 28772345.48 | DISTRITO CAPITAL | BOGOTA D.C. | 1701.0 | PONTIFICIA UNIVERSIDAD JAVERIANA | ARTES VISUALES | UNIVERSITARIA | ACCES | AMORTIZACION | COBRO ADMINISTRATIVO INGRESO | 2351493.36 | 1974883.40 | ACCES | 3.0 | F | SOLTERO(A) | N | (02) 1 - 30 | MILLENNIALS | 2017-04-29 | CUMPLIDO | ABONO | 1.0 | 0.0 | 0.0 | 2020-10-02 | 0 | 2.0 | INDRA COLOMBIA S A S | 2020-10 | 2020-10-01 | NaN | NaN | NaN | NaN |
| 5 | 11611 | 2020-11-01 | 2020-11-17 | 2020-11-17 | 2020-07-20 | 3.0 | 0.0 | 242481.68 | 0.00 | 3496093.91 | 2020-11-17 | K | 2010-01-31 | 2021-09-20 | 2020-10-24 | 13308548.27 | DISTRITO CAPITAL | BOGOTA D.C. | 2830.0 | CORPORACION UNIVERSITARIA IBEROAMERICANA | FISIOTERAPIA | UNIVERSITARIA | ACCES | AMORTIZACION | COBRO PREJURIDICO - INGRESO | 3548961.23 | 3476670.71 | ACCES | 2.0 | F | OTRO | E | NaN | NaN | 2017-10-23 | CUMPLIDO | ABONO | 1.0 | 0.0 | 0.0 | 2020-02-20 | 0 | 7.0 | NaN | NaN | NaN | 8.0 | 6.0 | 11.0 | EFECTIVO_REALIZA ACUERDO DE PAGO_REFINANCIACI N_NAN |
| 6 | 19061 | 2020-11-17 | NaN | 2020-11-17 | NaN | 0.0 | 6.0 | 76974.93 | 101598.30 | 1301706.74 | 2020-11-17 | K | 2009-06-23 | 2021-11-10 | 2020-10-15 | 6658620.73 | DISTRITO CAPITAL | BOGOTA D.C. | 1704.0 | UNIVERSIDAD SANTO TOMAS | CULTURA FISICA, DEPORTE Y RECREACION | UNIVERSITARIA | ACCES | AMORTIZACION | COBRO ADMINISTRATIVO INGRESO | 981064.89 | 981064.89 | ACCES | 2.0 | M | OTRO | N | (02) 1 - 30 | NaN | 2020-09-29 | CUMPLIDO | NORMALIZACION | NaN | NaN | NaN | NaN | 0 | 2.0 | SOCIEDAD CLINICA CASANARE LTDA | 2020-10 | 2020-10-01 | NaN | 1.0 | 4.0 | NO CONTACTADO_BUZON_NAN_NAN |
| 7 | 29708 | 2020-11-17 | NaN | 2020-11-17 | NaN | 0.0 | 6.0 | 242749.81 | 271990.92 | 9713836.58 | 2020-11-17 | K | 2009-12-06 | 2023-10-10 | 2020-10-26 | 32486333.69 | ATLANTICO | BARRANQUILLA | 1824.0 | UNIVERSIDAD METROPOLITANA | MEDICINA | UNIVERSITARIA | ACCES | AMORTIZACION | COBRO ADMINISTRATIVO DEVOLUCION | 8187188.16 | 8187188.16 | ACCES | 2.0 | M | OTRO | N | (02) 1 - 30 | NaN | 2016-04-28 | INCUMPLIDO | NORMALIZACION | 2.0 | 34.0 | 0.0 | 2020-10-02 | 343297 | 3.0 | DAVITA S.A.S. | 2020-10 | 2020-10-01 | 9.0 | 1.0 | 7.0 | EFECTIVO_NO REALIZA PAGO_RECLAMACI N_NAN |
| 8 | 43222 | 2020-11-01 | 2020-11-17 | 2020-11-17 | 2019-06-10 | 16.0 | 0.0 | 127736.53 | 0.00 | 2436116.54 | 2020-11-17 | K | 2009-06-30 | 2021-05-10 | 2019-08-28 | 10630503.06 | MAGDALENA | FUNDACION | 1804.0 | PA FIDUPREVISORAS A UNIVERSIDAD AUTONOMA DEL CARIBE | ADMINISTRACION DE EMPRESAS | UNIVERSITARIA | ACCES | AMORTIZACION | COBRO PREJURIDICO - INGRESO | 2943496.62 | 2435104.62 | ACCES | 1.0 | F | OTRO | E | NaN | NaN | 2020-09-11 | CUMPLIDO | REFINANCIACION | NaN | NaN | NaN | NaN | 0 | 2.0 | NaN | NaN | NaN | 13.0 | 5.0 | 7.0 | EFECTIVO_REALIZA ACUERDO DE PAGO_REFINANCIACION_GENERAL |
| 9 | 46319 | 2020-11-01 | 2020-11-17 | 2020-11-17 | 2020-03-20 | 6.0 | 0.0 | 113099.77 | 0.00 | 531835.54 | 2020-11-17 | K | 2019-04-20 | 2020-09-20 | 2020-02-13 | 6175296.15 | BOLIVAR | CARTAGENA | 2833.0 | CORPORACION UNIVERSITARIA REMINGTON | CONTADURIA PUBLICA | UNIVERSITARIA | ACCES | AMORTIZACION | COBRO PREJURIDICO - INGRESO | 781666.81 | 530666.81 | ACCES | 2.0 | M | SOLTERO(A) | E | NaN | NaN | 2019-03-15 | CUMPLIDO | REFINANCIACION | 1.0 | 0.0 | 0.0 | 2020-02-20 | 0 | 2.0 | NaN | NaN | NaN | 8.0 | 6.0 | 5.0 | EFECTIVO_REALIZA ACUERDO DE PAGO_REFINANCIACION_GENERAL |
Last rows
| IDSOLICITUD | FECHAENTRADA | FECHASALIDA | FECHAACTUALIZACION | FECHAMORADESDE | NROCUOTASMORA | NUMDIASMORA_ACT | VALORCUOTA | SALDOTOTALMORA1_ACT | SALDOTOTAL_ACT | FECHAMOVIMIENTO | CALIFICACIONACTUAL | VCTO_CUOTA1 | FECHA_VCTO | FECHAULTPAGO | SALDOINICIAAMORT | DEPTORESIDENCIA | MUNICRESIDENCIA | CODSNIES_INST | IES | NOMBREPROGRAMA | NIVELDEFORMACION | LINEA | TIPOCARTERA | ESTADOACTUAL | SALDOCAPITALACIERRE | CAPITALICETEX_ACT | SUBLINEA | ESTRATO | SEXO | ESTADOCIVIL | TIPONOVEDAD | Rangodiasmora | CONCEPTO | FECHA_ACUERDO | ESTADO_ACUERDO | TIPO_ACUERDO | CUOTAS_PAGADAS_ACUERDO | CUOTAS_MORA_ACUERDO | CUOTAS_FUTURAS_ACUERDO | fecha Venc Cuota Vigente | Valor Cuota Vigente | No. ACUERDOS DE PAGO | RazonSocial | UltimoPeriodoCotizado | FechaFosyga | Hora_ContactoEfectivo | Llamadas_recibidas | Llamadas_realizadas | Tipificacion | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 48972 | 104853 | 2018-11-01 | 2019-11-12 | 2018-11-01 | 2016-04-28 | 30.0 | 916.0 | 610970.0 | 22391877.00 | 45768569.33 | 2018-11-01 | K | 2011-04-28 | 2022-03-28 | 2016-03-29 | 62842638.83 | VALLE DEL CAUCA | CALI | 1805.0 | UNIVERSIDAD SANTIAGO DE CALI | MEDICINA | UNIVERSITARIA | ACCES | AMORTIZACION | NaN | 38377782.38 | 25585187.65 | ACCES | 2.0 | F | 1 | N | NaN | NaN | 2017-05-04 | INCUMPLIDO | ABONO | 0.0 | 1.0 | 0.0 | 2020-01-28 | 0 | 2.0 | NaN | NaN | NaN | 9.0 | NaN | 5.0 | NO CONTACTADO_BUZON_NAN_NAN |
| 48973 | 260045 | 2018-11-01 | 2019-11-12 | 2018-11-01 | 2018-05-15 | 5.0 | 169.0 | 237421.0 | 1457170.00 | 15717086.60 | 2018-11-01 | K | 2017-04-15 | 2024-03-15 | 2018-04-07 | 11485602.70 | PUTUMAYO | MOCOA | 3115.0 | INSTITUTO TECNOLOGICO DEL PUTUMAYO MOCOA | INGENIERIA DE SISTEMAS | UNIVERSITARIA | ACCES | AMORTIZACION | NaN | 11248350.86 | 11248350.86 | ACCES | 1.0 | M | 1 | N | (08) 181 - 270 | MILLENNIALS | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SECRETARIA DE EDUCACION DEPARTAMENTAL DE PUTUMAYO | 2020-01 | 2020-10-01 | NaN | NaN | NaN | NaN |
| 48974 | 260411 | 2018-11-01 | 2019-11-12 | 2018-11-01 | 2017-10-03 | 12.0 | 362.0 | 153471.0 | 2105091.00 | 2411649.36 | 2018-11-01 | K | 2009-12-06 | 2018-12-03 | 2017-11-29 | 6137108.41 | BOLIVAR | CARTAGENA | 1701.0 | PONTIFICIA UNIVERSIDAD JAVERIANA | LICENCIATURA EN LENGUAS MODERNAS | UNIVERSITARIA | ACCES | AMORTIZACION | NaN | 1435555.80 | 1435555.80 | ACCES | 2.0 | F | 1 | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 12.0 | NaN | 2.0 | EFECTIVO_COMPROMISO DE PAGO_NAN_NAN |
| 48975 | 434529 | 2018-11-01 | 2019-11-12 | 2018-11-01 | 2017-01-20 | 12.0 | 649.0 | 368257.0 | 4938139.38 | 4938139.38 | 2018-11-01 | K | 2017-01-20 | 2017-12-20 | NaN | 2552662.95 | NARINO | PASTO | 1720.0 | UNIVERSIDAD MARIANA | TERAPIA OCUPACIONAL | UNIVERSITARIA | LINEAS TRADICIONALES | AMORTIZACION | NaN | 2552662.96 | 2552662.96 | PREGRADO MP | 2.0 | F | 1 | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 48976 | 444162 | 2018-11-01 | 2019-11-12 | 2018-11-01 | 2017-01-20 | 6.0 | 649.0 | 328425.0 | 2450343.45 | 2450343.45 | 2018-11-01 | K | 2017-01-20 | 2017-06-20 | 2016-04-20 | 1933333.34 | ANTIOQUIA | ENVIGADO | 1812.0 | UNIVERSIDAD DE MEDELLIN | COMUNICACION Y LENGUAJES AUDIOVISUALES | UNIVERSITARIA | LINEAS TRADICIONALES | AMORTIZACION | NaN | 1933333.34 | 1933333.34 | PREGRADO MP | 3.0 | M | 1 | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 48977 | 1214479 | 2018-11-01 | 2019-11-12 | 2018-11-01 | 2018-04-10 | 6.0 | 174.0 | 204986.0 | 1316691.00 | 7749086.22 | 2018-11-01 | K | 2009-07-31 | 2021-07-10 | 2018-06-26 | 18345094.11 | DISTRITO CAPITAL | BOGOTA D.C. | 1725.0 | FUNDACION UNIVERSIDAD AUTONOMA DE COLOMBIA -FUAC- | DERECHO | UNIVERSITARIA | LINEAS TRADICIONALES | AMORTIZACION | NaN | 7022591.75 | 7022591.75 | PREGRADO LARGO PLAZO | NaN | F | 3 | N | NaN | NaN | 2017-06-30 | CUMPLIDO | REFINANCIACION | 1.0 | 0.0 | 0.0 | 2020-10-02 | 0 | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 48978 | 1522420 | 2018-11-01 | 2019-11-12 | 2018-11-01 | 2015-07-17 | 39.0 | 1202.0 | 132792.0 | 6704498.00 | 12144201.59 | 2018-11-01 | K | 2015-07-17 | 2022-06-17 | 2013-10-31 | 11261527.31 | VALLE DEL CAUCA | RIOFRIO | 2301.0 | UNIDAD CENTRAL DEL VALLE DEL CAUCA | DERECHO | UNIVERSITARIA | ACCES | AMORTIZACION | NaN | 9180833.59 | 9180833.59 | ACCES | 1.0 | M | 1 | N | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | NO EFECTIVO_NO LO CONOCEN_NAN_NAN |
| 48979 | 1731356 | 2018-11-01 | 2019-11-12 | 2018-11-01 | 2015-09-17 | 13.0 | 1140.0 | 72108.0 | 1341981.59 | 1341981.59 | 2018-11-01 | K | 2014-10-17 | 2016-09-17 | 2015-07-27 | 1800940.99 | SANTANDER | GIRON | 3201.0 | UNIDADES TECNOLOGICAS DE SANTANDER | TECNOLOGIA EN OPERACION Y MANTENIMIENTO ELECTROMECANICO | TECNOLOGICA TERMINAL | ACCES | AMORTIZACION | NaN | 920079.12 | 920079.12 | ACCES | 1.0 | M | 1 | N | NaN | NaN | 2017-10-25 | INCUMPLIDO | REFINANCIACION | 0.0 | 1.0 | 0.0 | NaN | 0 | 4.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 48980 | 1733481 | 2018-11-01 | 2019-11-12 | 2018-11-01 | 2015-12-17 | 34.0 | 1049.0 | 84446.0 | 3479513.00 | 6341023.00 | 2018-11-01 | K | 2015-12-17 | 2021-11-17 | 2014-06-24 | 6196785.00 | DISTRITO CAPITAL | BOGOTA D.C. | 4832.0 | CORPORACION INSTITUTO SUPERIOR DE EDUCACION SOCIAL | TECNICA PROFESIONAL EN DISENO GRAFICO | TECNICA PROFESIONAL | ACCES | AMORTIZACION | NaN | 4863852.46 | 4863852.46 | ACCES | 2.0 | M | 1 | N | NaN | NaN | 2020-02-20 | CUMPLIDO | REFINANCIACION | NaN | NaN | NaN | NaN | 0 | 2.0 | NaN | NaN | NaN | NaN | 2.0 | 3.0 | EFECTIVO_CR DITO ADMINISTRATIVO_NAN_NAN |
| 48981 | 2445369 | 2018-11-01 | 2019-11-12 | 2018-11-01 | 2016-01-20 | 6.0 | 984.0 | 326242.0 | 2337663.05 | 2337663.05 | 2018-11-01 | K | 2016-01-20 | 2016-06-20 | 2017-02-15 | 1937064.95 | DISTRITO CAPITAL | BOGOTA D.C. | 1709.0 | FUNDACION UNIVERSIDAD CENTRAL | PUBLICIDAD | UNIVERSITARIA | LINEAS TRADICIONALES | AMORTIZACION | NaN | 1632905.14 | 1632905.14 | PREGRADO MP | 2.0 | F | 1 | N | NaN | NaN | 2017-06-17 | INCUMPLIDO | REFINANCIACION | 0.0 | 1.0 | 0.0 | NaN | 0 | 4.0 | NaN | NaN | NaN | NaN | NaN | 1.0 | NO EFECTIVO_NO LO CONOCEN_NAN_NAN |